
HowdoIgeneratelotsofrandomnumbersfromaNormalDistributionN(0,1)Ie.Mean0Variance1?Thanks.,Usetheformula=NORMINV(RAND(),B2,C2),wheretheRAND()functioncreatesyourprobability,B2providesyourmeanandC2referencesyourstandarddeviation.,TousetheRANDfunctionv...
How to Generate a Normal Distribution in Excel
TogenerateanormaldistributioninExcel,youcanusethefollowingformula:=NORMINV(RAND(),MEAN,STANDARD_DEVIATION).
** 本站引用參考文章部分資訊,基於少量部分引用原則,為了避免造成過多外部連結,保留參考來源資訊而不直接連結,也請見諒 **